﻿CREATE TABLE [dbo].[AlertRule]
(
	[alert_rule_id] INT NOT NULL IDENTITY PRIMARY KEY, 
    [entity_type_property_id] INT NOT NULL, 
    [int_warning_value] INT NULL, 
    [int_alert_value] INT NULL, 
    [bigint_warning_value] BIGINT NULL, 
    [bigint_alert_value] BIGINT NULL, 
    [string_warning_value] VARCHAR(256) NULL, 
    [string_alert_value] VARCHAR(256) NULL, 
    [string_warning_type] TINYINT NULL, 
    [string_alert_type] TINYINT NULL, 
    [datetime_warning_value] INT NULL, 
    [datetime_alert_value] INT NULL, 
    [datetime_warning_type] TINYINT NULL, 
    [datetime_alert_type] TINYINT NULL, 
    [name] VARCHAR(256) NOT NULL, 
    [description] VARCHAR(2048) NOT NULL, 
    [cause] VARCHAR(2048) NOT NULL, 
    [resolution] VARCHAR(2048) NOT NULL
)
